package com.aaa.base.mapper;

import com.aaa.entity.base.Commodity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author aaa
 * @since 2020-11-23
 */
public interface CommodityMapper extends BaseMapper<Commodity> {
    /*通过仓库id查出当前仓库中所有的商品编码和名字*/
    @Select("select bar,name from b_commodity b where b.warehouseid=#{warehouseid}")
    List<Map> selectComBarNamByWareId(Long warehouseid);

}
